Notes/Domino Fix List
 |  |
| SPR # MGIY4G5SJD | Fixed in 5.0.3 release |  |
Product Area: Server Technical Area: DECS Platform: AS/400
SPR# MGIY4G5SJD - Fixed a problem with DECS failure when attempting to use a stored procedure written in RPG
Technote Number: 1099597
Problem:
This issue was reported to Quality Engineering and has been addressed in Domino
5.0.3.
This is actually an issue with the stored procedure; DECS is functioning as
designed.
Workaround: Use a stored procedure written in SQL.
Supporting Information:
When creating a SQLRPGLE stored procedure that will be used by DECS on the
AS/400, it is important to define the format of the parameter(s) that the
stored procedure passes to the DB/2 table, according to the field definitions
in the Notes NSF file. It is also important to note that the type of parameter
DECS passes to the stored procedure is the type of the key defined in the Notes
database, not what is defined in DB/2.
Example: You attempt to pass a field that is defined as type FLOAT in the .NSF
file, to a DB/2 table record that is defined as type NUMERIC. The SQLRPGLE
stored procedure must define its input data as type FLOAT. If it is not
defined to match what the .NSF file is presenting to it, the stored procedure
will pass the input data directly to the DB/2 table. If the definitions do not
match, then the data will appear as "garbage". More >
 A fix for this SPR has been developed but is currently undergoing testing. IBM reserves the right to remove this fix from the targeted release if it does not pass quality assurance tests. Please consider this information to be provisional. Do not base irreversible business decisions on this information until this notice has been removed.
 |
Last Modified on 04/03/2001
Go back
|